package com.topisv.tms.repository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.PerformanceFee;

public interface PerformanceFeeDao extends PagingAndSortingRepository<PerformanceFee, Long>, JpaSpecificationExecutor<PerformanceFee> {
	
	@Query("select t from PerformanceFee t where t.warehouseCode=?1 and t.customerCode=?2 and t.optype=?3")
	PerformanceFee findPerformanceFee(String warehouseCode,String customerCode,String optype);
}
